SAS^® Customer Intelligence campaign contact history records are not being updated as failed contacts when the associated SAS^® Digital Marketing broadcast e-mails return as hard bounces.

When the underlying database is Teradata, this might occur because the database schema is not known. The only way to deduce this is to review the SAS Customer Intelligence reporting log for the implicit pass-through SQL, which updates the contact history:

execute ( MERGE INTO CI_CELL_PACKAGE tt USING
PROD_MA_WRK_TB.CH_CP_FAILED_CNT121304 st ON ( tt.CELL_PACKAGE_SK =
st.CELL_PACKAGE_SK ) WHEN MATCHED THEN UPDATE SET
TOTAL_ATTEMPTED_CONTACT_CNT = TOTAL_ATTEMPTED_CONTACT_CNT - st.FAILED_CNT,
TOTAL_MARKETING_CONTACT_CNT = TOTAL_MARKETING_CONTACT_CNT - st.FAILED_CNT,
PROCESSED_DTTM = CURRENT_TIMESTAMP ) by TERADATA;

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Marketing Automation 5.4_M1 is available at:

A fix for this issue for SAS Marketing Automation 5.41 is available at: